﻿using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using DataAccess.Data;
namespace hrBll
{
    public class BllMain
    {
        /// <summary>
        /// 获得当天生日的员工名称
        /// </summary>
        /// <returns>DataTable对象</returns>
        public static DataTable GetEmp()
        {
            StringBuilder sb = new StringBuilder();
            sb.Append("SELECT EmployName FROM EMPLOYEE ");
            sb.Append("WHERE CAST(MONTH(BIRTHDAY) AS VARCHAR(2))+CAST(DAY(BIRTHDAY) AS VARCHAR(2))=CAST(MONTH(GETDATE()) AS VARCHAR(2))+CAST(DAY(GETDATE()) AS VARCHAR(2))");
           return  DbHelperSQL.Instance.GetDataTable(sb.ToString());
        }
    }
}